[dbo].[BAEHistoryInsert]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEHistoryInsert

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@IP	varchar(128)	128
@Description	varchar(1024)	1024
@EventType	varchar(256)	256

SQL Script

create procedure [dbo].[BAEHistoryInsert] @IP as
varchar(128),
    @Description AS varchar(1024),
    @EventType AS varchar(256)
AS
    INSERT INTO History
    (History.EventDate, History.IP, History.[Description], History.EventType)
    VALUES
    (GETDATE(), @IP, @Description, @EventType);

    SELECT (CAST (@@IDENTITY AS int)) AS 'HistoryId'

GO

Uses

[dbo].[History]
dbo